﻿CREATE TABLE [dbo].[CourseMaterials]
(
	[ID] INT NOT NULL PRIMARY KEY IDENTITY, 
    [CourseSemesterId] INT NOT NULL, 
    [FileName] NVARCHAR(250) NULL, 
    [FileUrl] NVARCHAR(250) NOT NULL, 
    [DoctorId] INT NULL, 
    CONSTRAINT [FK_CourseMaterials_CourseSemester] FOREIGN KEY ([CourseSemesterId]) REFERENCES [CourseSemester]([Id]), 
    CONSTRAINT [FK_CourseMaterials_ToDoctor] FOREIGN KEY ([DoctorId]) REFERENCES [Doctor]([ID])
)
